1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12
13 namespace SoftQuanLyNhaHang.Models
14 {
15 class ThongTinSanPhamMod
16 {
17 protected int IdThongTinSanPham { get; set; }
18 protected string MaSanPham { get; set; }
19 protected string TenSanPham { get; set; }
20 protected int NhaCungCapId { get; set; }
21 protected string TenNhaCungCap { get; set; }
22 protected int DonViTinhId { get; set; }
23 protected string TenDonViTinh { get; set; }
24 protected string GhiChu { get; set; }
25 protected DateTime NgayTao { get; set; }
26 protected int TrangThai { get; set; }
27
28
29 public ThongTinSanPhamMod(int _idThongTinSanPham)
30 {
31 IdThongTinSanPham = _idThongTinSanPham;
32 }
33
34 public ThongTinSanPhamMod(string _maSanPham)
35 {
36 MaSanPham = _maSanPham;
37 }
38
39 public ThongTinSanPhamMod()
40 {
41
42 }
43
44 public ThongTinSanPhamMod(int _idThongTinSanPham, string _maSanPham, string _tenSanPham, int _nhaCungCapId, string _tenNhaCungCap, int _donViTinhId, string _tenDonViTinh, string _ghiChu, DateTime _ngayTao, int _trangThai)
45 {
46 IdThongTinSanPham = _idThongTinSanPham;
47 MaSanPham = _maSanPham;
48 TenSanPham = _tenSanPham;
49 NhaCungCapId = _nhaCungCapId;
50 TenNhaCungCap = _tenNhaCungCap;
51 DonViTinhId = _donViTinhId;
52 TenDonViTinh = _tenDonViTinh;
53 GhiChu = _ghiChu;
54 NgayTao = _ngayTao;
55 TrangThai = _trangThai;
56 }
57
58 public int InsertThongTinSanPham()
59 {
60 int i = 0;
61 string[] paras = new string[10] { "@IdThongTinSanPham", "@MaSanPham","@TenSanPham", "@NhaCungCapId", "@TenNhaCungCap", "@DonViTinhId", "@TenDonViTinh", "@GhiChu", "@NgayTao", "@TrangThai"};
62 object[] values = new object[10] { IdThongTinSanPham, MaSanPham, TenSanPham, NhaCungCapId, TenNhaCungCap, DonViTinhId, TenDonViTinh, GhiChu, NgayTao, TrangThai};
63 i = Int32.Parse(Models.connection.ExcuteScalar("tbl_ThongTinSanPham_Insert", CommandType.StoredProcedure, paras, values));
64 return i;
65 }
66 public int UpdateThongTinSanPham()
67 {
68 int i = 0;
69 string[] paras = new string[10] { "@IdThongTinSanPham", "@MaSanPham", "@TenSanPham", "@NhaCungCapId", "@TenNhaCungCap", "@DonViTinhId", "@TenDonViTinh", "@GhiChu", "@NgayTao", "@TrangThai" };
70 object[] values = new object[10] { IdThongTinSanPham, MaSanPham, TenSanPham, NhaCungCapId, TenNhaCungCap, DonViTinhId, TenDonViTinh, GhiChu, NgayTao, TrangThai };
71 i = Models.connection.Excute_Sql("tbl_ThongTinSanPham_Update", CommandType.StoredProcedure, paras, values);
72 return i;
73 }
74
75 public int UpdateThongTinSanPhamDvt()
76 {
77 int i = 0;
78 string[] paras = new string[1] { "@IdThongTinSanPham"};
79 object[] values = new object[1] { IdThongTinSanPham};
80 i = Models.connection.Excute_Sql("tbl_ThongTinSanPham_UpdateIdDvt", CommandType.StoredProcedure, paras, values);
81 return i;
82 }
83
84
85 public int DeleteThongTinSanPham()
86 {
87 int i = 0;
88 string[] paras = new string[1] { "@IdThongTinSanPham" };
89 object[] values = new object[1] { IdThongTinSanPham };
90 i = Models.connection.Excute_Sql("tbl_ThongTinSanPham_Delete", CommandType.StoredProcedure, paras, values);
91 return i;
92 }
93
94 public DataSet FillDataSet_getThongTinSanPhamByMaSanPham()
95 {
96 DataSet ds = new DataSet();
97 string[] paras = new string[1] { "@MaSanPham" };
98 object[] values = new object[1] { MaSanPham };
99 ds = Models.connection.FillDataSet("tbl_ThongTinSanPham_Get_ByMaSanPham", CommandType.StoredProcedure, paras, values);
100 return ds;
101 }
102 }
103 }